﻿CREATE TABLE [dbo].[AmixCatalog] (
    [Grupa]           INT           NULL,
    [Subgrupa]        INT           NULL,
    [Clasa]           INT           NULL,
    [Subclasa]        INT           NULL,
    [Familia]         NVARCHAR (3)  NULL,
    [DMinAmortizare]  INT           NULL,
    [DMaxAmortizare]  INT           NULL,
    [ContImobilizare] VARCHAR (50)  NOT NULL,
    [ContAmortizare]  VARCHAR (50)  NOT NULL,
    [Denumire]        VARCHAR (150) CONSTRAINT [DF_CatalogAmix_Denumire] DEFAULT ('') NOT NULL,
    [IDClasificare]   INT           IDENTITY (1, 1) NOT NULL,
    [Cod]             VARCHAR (50)  CONSTRAINT [DF_CatalogAmix_Cod] DEFAULT ('') NULL,
    CONSTRAINT [PK_CatalogAmix] PRIMARY KEY CLUSTERED ([IDClasificare] ASC)
);

